SUPPORT / SAMPLES & SAS NOTES
 

Support

Installation Note 59231: "SSL Initialization failure" occurs when connecting with SAS/ACCESS® Interface to Amazon Redshift

DetailsAboutRate It

If you use SAS/ACCESS Interface to Amazon Redshift in a Windows environment, you might encounter the following error when attempting to use an SSL enabled connection:

ERROR: CLI error trying to establish connection: [SAS][ODBC Redshift Wire Protocol driver]
Unable to dynamically load client DLL [Install Dir]\SASHome\AccessClients\9.4\Redshift\s0ssl27.DLL. :
[SAS][ODBC Redshift Wire Protocol driver]SSL Initialization Failure. ERROR: Error in the LIBNAME statement.

This problem is the result of a missing DLL from the SAS/SECURE package that is required to establish an SSL enabled connection.  If this problem occurs, contact SAS Technical Support for assistance in obtaining and applying the required DLL.



Operating System and Release Information

Product FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS/ACCESS Interface to Amazon RedshiftMicrosoft® Windows® for x649.49.49.4 TS1M39.4 TS1M4
Microsoft Windows 8 Enterprise 32-bit9.49.49.4 TS1M39.4 TS1M4
Microsoft Windows 8 Enterprise x649.49.49.4 TS1M39.4 TS1M4
Microsoft Windows 8 Pro 32-bit9.49.49.4 TS1M39.4 TS1M4
Microsoft Windows 8 Pro x649.49.49.4 TS1M39.4 TS1M4
Microsoft Windows 8.1 Enterprise 32-bit9.49.49.4 TS1M39.4 TS1M4
Microsoft Windows 8.1 Enterprise x649.49.49.4 TS1M39.4 TS1M4
Microsoft Windows 8.1 Pro 32-bit9.49.49.4 TS1M39.4 TS1M4
Microsoft Windows 8.1 Pro x649.49.49.4 TS1M39.4 TS1M4
Microsoft Windows 109.49.49.4 TS1M39.4 TS1M4
Microsoft Windows Server 20089.49.49.4 TS1M39.4 TS1M4
Microsoft Windows Server 2008 R29.49.49.4 TS1M39.4 TS1M4
Microsoft Windows Server 2008 for x649.49.49.4 TS1M39.4 TS1M4
Microsoft Windows Server 2012 Datacenter9.49.49.4 TS1M39.4 TS1M4
Microsoft Windows Server 2012 R2 Datacenter9.49.49.4 TS1M39.4 TS1M4
Microsoft Windows Server 2012 R2 Std9.49.49.4 TS1M39.4 TS1M4
Microsoft Windows Server 2012 Std9.49.49.4 TS1M39.4 TS1M4
Windows 7 Enterprise 32 bit9.49.49.4 TS1M39.4 TS1M4
Windows 7 Enterprise x649.49.49.4 TS1M39.4 TS1M4
Windows 7 Home Premium 32 bit9.49.49.4 TS1M39.4 TS1M4
Windows 7 Home Premium x649.49.49.4 TS1M39.4 TS1M4
Windows 7 Professional 32 bit9.49.49.4 TS1M39.4 TS1M4
Windows 7 Professional x649.49.49.4 TS1M39.4 TS1M4
Windows 7 Ultimate 32 bit9.49.49.4 TS1M39.4 TS1M4
Windows 7 Ultimate x649.49.49.4 TS1M39.4 TS1M4
* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.